type
    TFFormat = (fftCSV, fftQuoted, fftFixed)  ;
    TStatFunc = (sfMAX, sfMIN, sfAVG) ;

GetFieldName(alius, tabname:String; fldnum:Byte) : String ;
{returns the field name of the field number <fldnum> for table <tabname> in database <alius>}

ColumnTotal(alius, tabname, valfield:String) : Double ;
{returns the total of all values in field <valfield> for table <tabname> in database <alius>}

ColumnStatVal(statfunc:TStatFunc; alius, tabname, Valfield:String) : Double ;
{returns the maximum/maximum/average value in field <valfield> for table <tabname> in database <alius>, depending upon TStatFunc type: so far thse can be sfMIN, sfMAX, sfAVG}

DS_ColumnTotal(datafrom:Tdataset; valfield:String) : Double ;
{returns the total of all values in field <valfield> for dataset <datafrom> }

GroupSummary(alius, sourcetab, targettab, groupbyfield:String; valfields:TStringList) : Byte ;
{creates a table <targettab> which has a summed value for each field listed in TStringList <valfields> for each unique entry in <groupbyfield>. Warning: destroys any any existing <targettab>. Returns 0 if successful}

ExportToTxt(alius, ourcetab:String; filenam:TFilename; Forma:TFFormat; withheader:Boolean) : Boolean ;
{creates file <filenam> in format <Forma> from table <sourcetab> current outputs are: CSV(fftCSV), CSV with quoted text(fftQuoted). If withheader=true then first row is fieldnames}

DS_ExportToTxt(datafrom:TdataSet; filenam:TFilename; Forma:TFFormat; withheader:Boolean) : Boolean ;
{creates file <filenam> in format <Forma> from Dataset <datafrom> current outputs are: CSV(fftCSV), CSV with quoted text(fftQuoted) If withheader=true then first row is fieldnames}

CreateFromCSV(alius, targettab:String; filenam:TFilename; withheader:Boolean) : Boolean ;
{creates a table in DataBase <alius> of type ttDefault and Named <targettab> using the file <filenam> which must be CSV.
If withheader=true the first row is taken as the field names. Warning: deletes any existing table <targettab>}

AppendFromCSV(alius, targettab:String; filenam:TFilename) : Boolean ;
{appends records to existing table <targettab>. File <filenam> must have same number of fields in same order}